package com.dpp.mapper;

import com.dpp.entity.Withdraw;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface WithdrawMapper {
    @Select("select * from withdraw where openid = #{openId} and status = 0")
    Withdraw selectByOpenId(String openid);
    @Insert("insert into withdraw(openid, withdraw_money, phone, withdraw_date, status)" +
            "values(#{openid},#{withdrawMoney},#{phone},#{withdrawDate},#{status} )")
    void insert(Withdraw withdraw1);

}
